Values for IANAAppCodePage Connection String Attribute

Information for UNIX users

Table F-1 lists supported values, along with a description, for the IANAAppCodePage connection string attribute at the time of this publication. Support for additional values may have been added since publication time; therefore, for up-to-date values, go to:

http://www.datadirect.com/support/troubleshooting/su-faq-iana/index.ssp

See "Connecting Using a Connection String" for more information about this connection string attribute.

To determine the correct numeric value (the MIBenum value) for the IANAAppCodePage connection string attribute, do the following:

  1. Determine the code page of your database.
  2. Determine the MIBenum value that corresponds to your database code page. To do this, go to:
  3. http://www.iana.org/assignments/character-sets

    On this Web page, search for the name of your database code page. This name will be listed as an alias or the name of a character set and will have a MIBenum value associated with it.

  4. Check the table in this appendix to make sure that the MIBenum value you looked up on the IANA Web page is supported by SequeLink Client for ODBC. If the value is not listed, contact DataDirect Technologies technical support to request that support for that value be added.
  5. Table F-1. IANAAppCodePage Values 
    IANAAppCodePage
    IANA Character Set Name
    3
    US_ASCII
    4
    ISO_8859_1
    5
    ISO_8859_2
    6
    ISO_8859_3
    8
    ISO_8859_5
    9
    ISO_8859_6
    10
    ISO_8859_7
    11
    ISO_8859_8
    12
    ISO_8859_9
    17
    Shift_JIS
    18
    EUC_JP
    38
    EUC_KR
    106
    UTF-8
    109
    ISO_8859_13
    111
    ISO_8859_15
    113
    GBK
    114
    GB18030
    2004
    HP_ROMAN8
    2009
    IBM850
    2025
    2025 GB2312
    2026
    Big5
    2084
    KOI8_R
    2088
    KOI8-U
    2251
    WINDOWS_1251
    2252
    WINDOWS_1252
    2259
    TIS_620
    10001
    IBM-856
    10003
    IBM-921
    10004
    IBM-922
    10012
    IBM-943
    10024
    IBM-1046
    10030
    IBM-1124

Solaris

Table F-2 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the Solaris platform.

Table F-2. Code Pages Supported on Solaris 
Code page
IANA Character Set Name
IANAAppCodePage
646
US_ASCII
3
ISO8859-1
ISO_8859_1
4
ISO8859-2
ISO_8859_2
5
ISO8859-5
ISO_8859_5
8
ISO8859-6
ISO_8859_6
9
ISO8859-7
ISO_8859_7
10
ISO8859-8
ISO_8859_8
11
ISO8859-9
ISO_8859_9
12
PCK
Shift_JIS
17
eucJP
EUC_JP
18
ISO8859-13
ISO_8859_13
109
ISO8859-15
ISO_8859_15
111
GBK
GBK
113
UTF-8
UTF-8
106
gb2312
GB2312
2025
BIG5
Big5
2026
KOI8-R
KOI8_R
2084
TIS620.2533
TIS_620
2259

HP

Table F-3 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the HP-UX platform.

Table F-3. Code Pages Supported on HP-UX 
Code page
IANA Character Set Name
IANAAppCodePage
iso88591
ISO_8859_1
4
iso88592
ISO_8859_2
5
iso88595
ISO_8859_5
8
iso88596
ISO_8859_6
9
iso88597
ISO_8859_7
10
iso88598
ISO_8859_8
11
iso88599
ISO_8859_9
12
utf8
UTF-8
106
big5
Big5
2026
tis620
TIS_620
2259
roman8
HP_ROMAN8
2004

AIX

Table F-4 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the AIX platform.

Table F-4. Code Pages Supported on AIX 
Code Page
IANA Character Set Name
IANAAppCodePage
kIANACS_MIB_US_ ASCII
US_ASCII
3
ISO8859-1
ISO_8859_1
4
ISO8859-2
ISO_8859_2
5
ISO8859-5
ISO_8859_5
8
ISO8859-6
ISO_8859_6
9
ISO8859-7
ISO_8859_7
10
ISO8859-8
ISO_8859_8
11
ISO8859-9
ISO_8859_9
12
IBM-eucJP
EUC_JP
18
IBM-eucKR
EUC_KR
38
ISO8859-15
ISO_8859_15
111
GBK
GBK
113
UTF-8
UTF-8
106
IBM-850
IBM-850
2009
big5
Big5
2026
IBM-1252
WINDOWS_1252
2252
TIS-620
TIS_620
2259
IBM-856
IBM-856
10001
IBM-921
IBM-921
10003
IBM-922
IBM-922
10004
IBM-943
IBM-943
10012
IBM-1046
IBM-1046
10024
IBM-1124
IBM-1124
10030

Linux

Table F-5 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the Linux platform.

Table F-5. Code Pages Supported on Linux 
Code Page
IANA Character Set Name
IANAAppCodePage
ANSI_X3.4-1968
US_ASCII
3
ISO-8859-1
ISO_8859_1
4
ISO-8859-2
ISO_8859_2
5
ISO-8859-3
ISO_8859_3
6
ISO-8859-5
ISO_8859_5
8
ISO-8859-5
ISO_8859_6
9
ISO-8859-7
ISO_8859_7
10
ISO-8859-8
ISO_8859_8
11
ISO-8859-9
ISO_8859_9
12
EUC-JP
EUC_JP
18
EUC-KR
EUC_KR
38
ISO-8859-13
ISO_8859_13
109
ISO-8859-15
ISO_8859_15
111
GBK
GBK
113
GB18030
GB18030
114
UTF-8
UTF-8
106
GB2312
2025 GB2312
2025
BIG5
Big5
2026
KOI8-R
KOI8_R
2084
KOI8-U
KOI8-U
2088
CP1251
WINDOWS_1251
2251
TIS-620
TIS_620
2259

Windows

Table F-6 lists supported code pages, code page name, MIB number, and IANA character set name for the SequeLink Client 6.0 or higher for ODBC on the Windows platform.

Table F-6. Code Pages Supported on Windows 
Codepage
Codepage Name
MIBenum
IANA Character Set Name
932
Japanese Shift-JIS
17
Shift_JIS
936
Simplified Chinese GBK
113
GBK
949
Korean
10015
WINDOWS_949
950
Simplified Chinese Big5
2026
Big5
1250
Central Europe
2250
WINDOWS_1251
1251
Cyrillic
2251
WINDOWS_1251
1252
Latin I
2252
WINDOWS_1252
1253
Greek
2253
WINDOWS_1253
1254
Turkish
2254
WINDOWS_1254
1255
Hebrew
2255
WINDOWS_1255
1256
Arabic
2256
WINDOWS_1256
1257
Baltic
2257
WINDOWS_1257
1258
Vietnam
2258
WINDOWS_1258